﻿CREATE TABLE [dbo].[Periodo] (
    [IdPeriodo]   INT          IDENTITY (1, 1) NOT NULL,
    [IdCurso]     INT          NOT NULL,
    [FechaInicio] DATETIME     NOT NULL,
    [FechaFin]    DATETIME     NOT NULL,
    [Estado]      VARCHAR (20) NOT NULL,
    PRIMARY KEY CLUSTERED ([IdPeriodo] ASC),
    CONSTRAINT [FK_Periodo_Curso] FOREIGN KEY ([IdCurso]) REFERENCES [dbo].[Curso] ([IdCurso])
);

